﻿CREATE TABLE [MaintenanceService].[TaskInfo] (
    [TaskInfoId]         UNIQUEIDENTIFIER NOT NULL,
    [TaskCode]           INT              NOT NULL,
    [Name]               NVARCHAR (100)   NOT NULL,
    [DateAdded]          DATETIME         NOT NULL,
    [IntervalDays]       INT              NOT NULL,
    [LastExecuted]       DATETIME         NULL,
    [StoreProcedureName] NVARCHAR (100)   NULL,
    [AssemblyFullPath]   NVARCHAR (100)   NULL
);




